RelatedItemAssociationSalesSummary

Entity Definition

Logical Name : RelatedItemAssociationSalesSummary
Physical Name : LE_SLS_RLTD_ASCTN

A collection of accumulators for an association between two items that are generally sold together. For each association between related items, transaction and sales summaries will be calculated to analyze how frequently they are purchased together in a sale and how frequently they are purchased separately.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) RelatedItemAssociation(CO_ASCTN_RLTD_ITM)
RelatedItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_RLTD IdentityUUID char(32) RelatedItemAssociation(CO_ASCTN_RLTD_ITM)
RelatedItemAssociationTypeCode (FK)(PK) A retailer assigned code defining a type of association between two items that are generally sold together. CD_TYP_RLTD_ITM Code2 char(2) RelatedItemAssociation(CO_ASCTN_RLTD_ITM)
SoldTogetherTransactionCount A count of the number of transactions in which the items in the item association were sold together. QU_TRN_ASCTN_SD_TG QuantityTransactionCount decimal(7,0)
SoldSeparatelyTransactionCount Count of transactions in which the item is sold without the associated item. QU_ITM_SD_SPRTLY QuantityTransactionCount decimal(7,0)
RelatedItemSoldSeparatelyTransactionCount Count of transactions in which the associated item is sold without the item. QU_TRN_SLD_SPRTLY QuantityTransactionCount decimal(7,0)
TotalSalesTransactionCount Total sale transaction count for the same period as the item association accumulators - used to calculate ratios and percentages. QU_TRN_SLS_TOT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
ReportingPeriod delineates RelatedItemAssociationSalesSummary
RetailStore delineates RelatedItemAssociationSalesSummary
RelatedItemAssociation is tracked by RelatedItemAssociationSalesSummary

Logical Views containing RelatedItemAssociationSalesSummary

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03200 - Reporting - Item Sales View